Interim Data Profile

Dataset statistics

Number of variables	20
Number of observations	587554
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	66.1 MiB
Average record size in memory	118.0 B

Variable types

Numeric	16
DateTime	1
Categorical	3

Alerts

`AdGroupName` has a high cardinality: 1557 distinct values	High cardinality
`Criteria` has a high cardinality: 4262 distinct values	High cardinality
`AdGroupId` is highly overall correlated with `CampaignId` and 1 other fields	High correlation
`CampaignId` is highly overall correlated with `AdGroupId` and 1 other fields	High correlation
`AbsoluteTopImpressionPercentage` is highly overall correlated with `TopImpressionPercentage` and 7 other fields	High correlation
`TopImpressionPercentage` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 3 other fields	High correlation
`SearchImpressionShare` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 7 other fields	High correlation
`SearchTopImpressionShare` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 7 other fields	High correlation
`Impressions` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 7 other fields	High correlation
`Clicks` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 6 other fields	High correlation
`Cost` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 6 other fields	High correlation
`Sessions` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 6 other fields	High correlation
`Cost_gbp` is highly overall correlated with `AbsoluteTopImpressionPercentage` and 6 other fields	High correlation
`Margin` is highly overall correlated with `ROI_gbp`	High correlation
`ROI_gbp` is highly overall correlated with `Margin`	High correlation
`CampaignName` is highly overall correlated with `AdGroupId` and 1 other fields	High correlation
`Impressions` is highly skewed (γ1 = 29.86271315)	Skewed
`Clicks` is highly skewed (γ1 = 31.81868362)	Skewed
`Cost` is highly skewed (γ1 = 34.58918393)	Skewed
`Sessions` is highly skewed (γ1 = 31.81933403)	Skewed
`Cost_gbp` is highly skewed (γ1 = 34.58970642)	Skewed
`Margin` is highly skewed (γ1 = 32.55780029)	Skewed
`ROI_gbp` is highly skewed (γ1 = 68.26132965)	Skewed
`AbsoluteTopImpressionPercentage` has 314320 (53.5%) zeros	Zeros
`TopImpressionPercentage` has 236197 (40.2%) zeros	Zeros
`SearchImpressionShare` has 193541 (32.9%) zeros	Zeros
`SearchTopImpressionShare` has 193576 (32.9%) zeros	Zeros
`SearchRankLostTopImpressionShare` has 282797 (48.1%) zeros	Zeros
`Impressions` has 228327 (38.9%) zeros	Zeros
`Clicks` has 370319 (63.0%) zeros	Zeros
`Cost` has 370319 (63.0%) zeros	Zeros
`Sessions` has 370324 (63.0%) zeros	Zeros
`Cost_gbp` has 370324 (63.0%) zeros	Zeros
`Margin` has 568930 (96.8%) zeros	Zeros
`ROI_gbp` has 571589 (97.3%) zeros	Zeros

Reproduction

Analysis started	2023-03-09 09:22:37.603575
Analysis finished	2023-03-09 09:24:10.827635
Duration	1 minute and 33.22 seconds
Software version	ydata-profiling vv4.1.0
Download configuration	config.json

AdGroupId
Real number (ℝ)

Distinct	1557
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4350075 × 10¹¹

Minimum	1.3837406 × 10¹¹
Maximum	1.4905426 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 MiB

Quantile statistics

Minimum	1.3837406 × 10¹¹
5-th percentile	1.4074527 × 10¹¹
Q1	1.4228448 × 10¹¹
median	1.4366583 × 10¹¹
Q3	1.4386994 × 10¹¹
95-th percentile	1.4637224 × 10¹¹
Maximum	1.4905426 × 10¹¹
Range	1.0680203 × 10¹⁰
Interquartile range (IQR)	1.5854578 × 10⁹

Descriptive statistics

Standard deviation	1.9838267 × 10⁹
Coefficient of variation (CV)	0.013824505
Kurtosis	-0.66848392
Mean	1.4350075 × 10¹¹
Median Absolute Deviation (MAD)	1.3813464 × 10⁹
Skewness	0.35668222
Sum	8.4314437 × 10¹⁶
Variance	3.9355684 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.463722288 × 10¹¹	8083	1.4%
1.436658239 × 10¹¹	5754	1.0%
1.463722283 × 10¹¹	5617	1.0%
1.436658277 × 10¹¹	3973	0.7%
1.463722298 × 10¹¹	3699	0.6%
1.436658288 × 10¹¹	3699	0.6%
1.46372229 × 10¹¹	3699	0.6%
1.463722279 × 10¹¹	3425	0.6%
1.463722278 × 10¹¹	3288	0.6%
1.407452699 × 10¹¹	3077	0.5%
Other values (1547)	543240	92.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.383740608 × 10¹¹	74	< 0.1%
1.383740634 × 10¹¹	74	< 0.1%
1.383740701 × 10¹¹	74	< 0.1%
1.383740761 × 10¹¹	74	< 0.1%
1.391787481 × 10¹¹	74	< 0.1%
1.407452488 × 10¹¹	137	< 0.1%
1.407452489 × 10¹¹	274	< 0.1%
1.407452491 × 10¹¹	274	< 0.1%
1.407452491 × 10¹¹	137	< 0.1%
1.407452495 × 10¹¹	137	< 0.1%

Value	Count	Frequency (%)
1.490542636 × 10¹¹	274	< 0.1%
1.490542634 × 10¹¹	137	< 0.1%
1.490542634 × 10¹¹	137	< 0.1%
1.490542633 × 10¹¹	137	< 0.1%
1.490542632 × 10¹¹	274	< 0.1%
1.490542631 × 10¹¹	137	< 0.1%
1.490542631 × 10¹¹	274	< 0.1%
1.490542629 × 10¹¹	137	< 0.1%
1.490542629 × 10¹¹	137	< 0.1%
1.490542629 × 10¹¹	137	< 0.1%

CampaignId
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9031107 × 10¹⁰

Minimum	1.9026017 × 10¹⁰
Maximum	1.9033111 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 MiB

Quantile statistics

Minimum	1.9026017 × 10¹⁰
5-th percentile	1.9026017 × 10¹⁰
Q1	1.903261 × 10¹⁰
median	1.903261 × 10¹⁰
Q3	1.9032615 × 10¹⁰
95-th percentile	1.9032616 × 10¹⁰
Maximum	1.9033111 × 10¹⁰
Range	7094642
Interquartile range (IQR)	5073

Descriptive statistics

Standard deviation	2774791
Coefficient of variation (CV)	0.00014580292
Kurtosis	-0.33683575
Mean	1.9031107 × 10¹⁰
Median Absolute Deviation (MAD)	5073
Skewness	-1.2888598
Sum	1.1181803 × 10¹⁶
Variance	7.6994653 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1.903261505 × 10¹⁰	237889	40.5%
1.903260998 × 10¹⁰	174199	29.6%
1.902601654 × 10¹⁰	134540	22.9%
1.903261554 × 10¹⁰	32928	5.6%
1.903311119 × 10¹⁰	5669	1.0%
1.903261861 × 10¹⁰	2329	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.902601654 × 10¹⁰	134540	22.9%
1.903260998 × 10¹⁰	174199	29.6%
1.903261505 × 10¹⁰	237889	40.5%
1.903261554 × 10¹⁰	32928	5.6%
1.903261861 × 10¹⁰	2329	0.4%
1.903311119 × 10¹⁰	5669	1.0%

Value	Count	Frequency (%)
1.903311119 × 10¹⁰	5669	1.0%
1.903261861 × 10¹⁰	2329	0.4%
1.903261554 × 10¹⁰	32928	5.6%
1.903261505 × 10¹⁰	237889	40.5%
1.903260998 × 10¹⁰	174199	29.6%
1.902601654 × 10¹⁰	134540	22.9%

CriterionId
Real number (ℝ)

Distinct	4320
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5531408 × 10¹¹

Minimum	10341671
Maximum	1.906812 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 MiB

Quantile statistics

Minimum	10341671
5-th percentile	4.7335553 × 10⁸
Q1	1.7859937 × 10¹⁰
median	3.2558629 × 10¹¹
Q3	1.1622141 × 10¹²
95-th percentile	1.7134322 × 10¹²
Maximum	1.906812 × 10¹²
Range	1.9068017 × 10¹²
Interquartile range (IQR)	1.1443541 × 10¹²

Descriptive statistics

Standard deviation	5.5436262 × 10¹¹
Coefficient of variation (CV)	0.99828664
Kurtosis	-0.8938073
Mean	5.5531408 × 10¹¹
Median Absolute Deviation (MAD)	3.2170802 × 10¹¹
Skewness	0.72089943
Sum	3.2627701 × 10¹⁷
Variance	3.0731792 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.380522169 × 10¹¹	274	< 0.1%
1.715518424 × 10¹²	211	< 0.1%
1.712847985 × 10¹²	211	< 0.1%
1.71343222 × 10¹²	211	< 0.1%
1.713432216 × 10¹²	211	< 0.1%
1.715180489 × 10¹²	211	< 0.1%
1.743196683 × 10¹²	211	< 0.1%
1.7131332 × 10¹²	211	< 0.1%
1.713432224 × 10¹²	211	< 0.1%
1.676901421 × 10¹²	211	< 0.1%
Other values (4310)	585381	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10341671	137	< 0.1%
11350301	137	< 0.1%
12621993	137	< 0.1%
12685701	137	< 0.1%
17218370	137	< 0.1%
19413601	137	< 0.1%
19413681	137	< 0.1%
20847170	137	< 0.1%
20847200	137	< 0.1%
20847260	137	< 0.1%

Value	Count	Frequency (%)
1.906811999 × 10¹²	137	< 0.1%
1.906811999 × 10¹²	63	< 0.1%
1.906811999 × 10¹²	137	< 0.1%
1.906811998 × 10¹²	63	< 0.1%
1.906811997 × 10¹²	63	< 0.1%
1.906811995 × 10¹²	63	< 0.1%
1.906811995 × 10¹²	137	< 0.1%
1.906811995 × 10¹²	137	< 0.1%
1.906811994 × 10¹²	210	< 0.1%
1.906811993 × 10¹²	211	< 0.1%

Date
Date

Distinct	137
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.0 MiB

Minimum	2022-09-15 00:00:00
Maximum	2023-01-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

CampaignName
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.0 MiB

GEN_Type_Date	127271
GEN_Type_Date _Metis	110618
GEN_Type_Type	93754
GEN_Type_Type _Metis	80445
GEN_Date	72300
Other values (7)	103166

Length

Max length	30
Median length	25
Mean length	14.907226
Min length	8

Characters and Unicode

Total characters	8758800
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GEN_Date
2nd row	GEN_Type_Type
3rd row	GEN_Type_Date
4th row	GEN_Type_Date
5th row	GEN_Date

Common Values

Value	Count	Frequency (%)
GEN_Type_Date	127271	21.7%
GEN_Type_Date _Metis	110618	18.8%
GEN_Type_Type	93754	16.0%
GEN_Type_Type _Metis	80445	13.7%
GEN_Date	72300	12.3%
GEN_Date _Metis	62240	10.6%
GEN_From	17682	3.0%
GEN_From _Metis	15246	2.6%
GEN_Type_Type_From	2960	0.5%
GEN_Type_Type_From _Metis	2709	0.5%
Other values (2)	2329	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
metis	272329	31.7%
gen_type_date	237889	27.7%
gen_type_type	174199	20.3%
gen_date	134540	15.6%
gen_from	32928	3.8%
gen_type_type_from	5669	0.7%
gen_type_type_type_type	2329	0.3%

Most occurring characters

Value	Count	Frequency (%)
_	1290296	14.7%
e	1251699	14.3%
t	644758	7.4%
T	606941	6.9%
y	606941	6.9%
p	606941	6.9%
G	587554	6.7%
E	587554	6.7%
N	587554	6.7%
a	372429	4.3%
Other values (9)	1616133	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4143217	47.3%
Uppercase Letter	3052958	34.9%
Connector Punctuation	1290296	14.7%
Space Separator	272329	3.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1251699	30.2%
t	644758	15.6%
y	606941	14.6%
p	606941	14.6%
a	372429	9.0%
i	272329	6.6%
s	272329	6.6%
r	38597	0.9%
o	38597	0.9%
m	38597	0.9%

Uppercase Letter

Value	Count	Frequency (%)
T	606941	19.9%
G	587554	19.2%
E	587554	19.2%
N	587554	19.2%
D	372429	12.2%
M	272329	8.9%
F	38597	1.3%

Connector Punctuation

Value	Count	Frequency (%)
_	1290296	100.0%

Space Separator

Value	Count	Frequency (%)
	272329	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7196175	82.2%
Common	1562625	17.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1251699	17.4%
t	644758	9.0%
T	606941	8.4%
y	606941	8.4%
p	606941	8.4%
G	587554	8.2%
E	587554	8.2%
N	587554	8.2%
a	372429	5.2%
D	372429	5.2%
Other values (7)	971375	13.5%

Common

Value	Count	Frequency (%)
_	1290296	82.6%
	272329	17.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8758800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	1290296	14.7%
e	1251699	14.3%
t	644758	7.4%
T	606941	6.9%
y	606941	6.9%
p	606941	6.9%
G	587554	6.7%
E	587554	6.7%
N	587554	6.7%
a	372429	4.3%
Other values (9)	1616133	18.5%

AdGroupName
Categorical

Distinct	1557
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	9.0 MiB

GEN_January_Exact	8083
GEN_All Inclusive_Cheap_Exact	5754
GEN_February_Exact	5617
GEN_Cheap_Family_Exact	3973
GEN_Winter_Exact	3699
Other values (1552)	560428

Length

Max length	45
Median length	39
Mean length	22.943246
Min length	11

Characters and Unicode

Total characters	13480396
Distinct characters	56
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GEN_2023_Easter_Exact
2nd row	GEN_5 Star_Beach_BMM
3rd row	GEN_Cheap_Christmas_Exact
4th row	GEN_Deals_January_Exact
5th row	GEN_2023_August_BMM

Common Values

Value	Count	Frequency (%)
GEN_January_Exact	8083	1.4%
GEN_All Inclusive_Cheap_Exact	5754	1.0%
GEN_February_Exact	5617	1.0%
GEN_Cheap_Family_Exact	3973	0.7%
GEN_Winter_Exact	3699	0.6%
GEN_Cheap_Package_Exact	3699	0.6%
GEN_March_Exact	3699	0.6%
GEN_December_Exact	3425	0.6%
GEN_Christmas_Exact	3288	0.6%
GEN_All Inclusive_2023_Exact	3077	0.5%
Other values (1547)	543240	92.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gen_all	63868	8.3%
go	10275	1.3%
gen_last	9453	1.2%
gen_5	8493	1.1%
gen_kids	8357	1.1%
gen_january_exact	8083	1.0%
minute_exact	7946	1.0%
year_exact	6301	0.8%
inclusive_cheap_exact	5754	0.7%
gen_february_exact	5617	0.7%
Other values (1511)	637342	82.6%

Most occurring characters

Value	Count	Frequency (%)
_	1739156	12.9%
E	1011695	7.5%
a	1009887	7.5%
e	794874	5.9%
t	679184	5.0%
N	616049	4.6%
G	612001	4.5%
c	599508	4.4%
l	439466	3.3%
M	434516	3.2%
Other values (46)	5544060	41.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6915504	51.3%
Uppercase Letter	3853238	28.6%
Connector Punctuation	1739156	12.9%
Decimal Number	782535	5.8%
Space Separator	183935	1.4%
Other Punctuation	5480	< 0.1%
Dash Punctuation	548	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1009887	14.6%
e	794874	11.5%
t	679184	9.8%
c	599508	8.7%
l	439466	6.4%
r	432886	6.3%
x	420179	6.1%
s	328394	4.7%
u	319985	4.6%
i	289991	4.2%
Other values (13)	1601150	23.2%

Uppercase Letter

Value	Count	Frequency (%)
E	1011695	26.3%
N	616049	16.0%
G	612001	15.9%
M	434516	11.3%
B	265141	6.9%
C	172889	4.5%
S	108715	2.8%
A	106187	2.8%
I	78114	2.0%
F	74048	1.9%
Other values (12)	373883	9.7%

Decimal Number

Value	Count	Frequency (%)
2	429729	54.9%
0	193168	24.7%
3	109872	14.0%
4	40177	5.1%
5	8493	1.1%
1	548	0.1%
8	548	0.1%

Connector Punctuation

Value	Count	Frequency (%)
_	1739156	100.0%

Space Separator

Value	Count	Frequency (%)
	183935	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	5480	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	548	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10768742	79.9%
Common	2711654	20.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1011695	9.4%
a	1009887	9.4%
e	794874	7.4%
t	679184	6.3%
N	616049	5.7%
G	612001	5.7%
c	599508	5.6%
l	439466	4.1%
M	434516	4.0%
r	432886	4.0%
Other values (35)	4138676	38.4%

Common

Value	Count	Frequency (%)
_	1739156	64.1%
2	429729	15.8%
0	193168	7.1%
	183935	6.8%
3	109872	4.1%
4	40177	1.5%
5	8493	0.3%
&	5480	0.2%
1	548	< 0.1%
8	548	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13480396	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
_	1739156	12.9%
E	1011695	7.5%
a	1009887	7.5%
e	794874	5.9%
t	679184	5.0%
N	616049	4.6%
G	612001	4.5%
c	599508	4.4%
l	439466	3.3%
M	434516	3.2%
Other values (46)	5544060	41.1%

Criteria
Categorical

Distinct	4262
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	9.0 MiB

all inclusive 21	337
all inclusive 2024	274
august holidays 2024	274
may holidays 2024	274
summer holidays 2024	274
Other values (4257)	586121

Length

Max length	47
Median length	39
Mean length	24.550275
Min length	8

Characters and Unicode

Total characters	14424612
Distinct characters	39
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	easter 2023 holidays
2nd row	+beach +holidays +5 +star
3rd row	cheap christmas vacations
4th row	jan holiday deals
5th row	+august +vacations +2023

Common Values

Value	Count	Frequency (%)
all inclusive 21	337	0.1%
all inclusive 2024	274	< 0.1%
august holidays 2024	274	< 0.1%
may holidays 2024	274	< 0.1%
summer holidays 2024	274	< 0.1%
honeymoon holidays 2024	274	< 0.1%
long haul holidays 2024	274	< 0.1%
holidays 2024	274	< 0.1%
villa holidays 2024	274	< 0.1%
family holidays 2024	274	< 0.1%
Other values (4252)	584751	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
holidays	321971	15.4%
holiday	151677	7.3%
2023	108313	5.2%
cheap	91908	4.4%
inclusive	67293	3.2%
all	66408	3.2%
in	49919	2.4%
2022	44214	2.1%
2024	38807	1.9%
deals	38577	1.9%
Other values (300)	1105193	53.0%

Most occurring characters

Value	Count	Frequency (%)
	1496726	10.4%
a	1346986	9.3%
l	997333	6.9%
i	995860	6.9%
s	909723	6.3%
e	891842	6.2%
o	840980	5.8%
h	724454	5.0%
d	664161	4.6%
y	634129	4.4%
Other values (29)	4922418	34.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11533517	80.0%
Space Separator	1496726	10.4%
Decimal Number	787222	5.5%
Math Symbol	606462	4.2%
Other Punctuation	548	< 0.1%
Dash Punctuation	137	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1346986	11.7%
l	997333	8.6%
i	995860	8.6%
s	909723	7.9%
e	891842	7.7%
o	840980	7.3%
h	724454	6.3%
d	664161	5.8%
y	634129	5.5%
r	532549	4.6%
Other values (15)	2995500	26.0%

Decimal Number

Value	Count	Frequency (%)
2	430633	54.7%
0	193389	24.6%
3	110642	14.1%
4	40725	5.2%
5	8767	1.1%
1	1696	0.2%
8	685	0.1%
6	411	0.1%
9	137	< 0.1%
7	137	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1496726	100.0%

Math Symbol

Value	Count	Frequency (%)
+	606462	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	548	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	137	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11533517	80.0%
Common	2891095	20.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1346986	11.7%
l	997333	8.6%
i	995860	8.6%
s	909723	7.9%
e	891842	7.7%
o	840980	7.3%
h	724454	6.3%
d	664161	5.8%
y	634129	5.5%
r	532549	4.6%
Other values (15)	2995500	26.0%

Common

Value	Count	Frequency (%)
	1496726	51.8%
+	606462	21.0%
2	430633	14.9%
0	193389	6.7%
3	110642	3.8%
4	40725	1.4%
5	8767	0.3%
1	1696	0.1%
8	685	< 0.1%
'	548	< 0.1%
Other values (4)	822	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14424612	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1496726	10.4%
a	1346986	9.3%
l	997333	6.9%
i	995860	6.9%
s	909723	6.3%
e	891842	6.2%
o	840980	5.8%
h	724454	5.0%
d	664161	4.6%
y	634129	4.4%
Other values (29)	4922418	34.1%

CpcBid
Real number (ℝ)

Distinct	596
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1496894.5

Minimum	84000
Maximum	12768000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	84000
5-th percentile	612000
Q1	972000
median	1356000
Q3	1800000
95-th percentile	2868000
Maximum	12768000
Range	12684000
Interquartile range (IQR)	828000

Descriptive statistics

Standard deviation	783306.5
Coefficient of variation (CV)	0.52328771
Kurtosis	12.465784
Mean	1496894.5
Median Absolute Deviation (MAD)	408000
Skewness	2.3344989
Sum	8.7950635 × 10¹¹
Variance	6.1356907 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1572000	13492	2.3%
1356000	7487	1.3%
1092000	6738	1.1%
1260000	6631	1.1%
1644000	6534	1.1%
1104000	6290	1.1%
1212000	6273	1.1%
1332000	6204	1.1%
900000	6143	1.0%
1200000	5925	1.0%
Other values (586)	515837	87.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
84000	1	< 0.1%
96000	1	< 0.1%
108000	7	< 0.1%
120000	18	< 0.1%
132000	11	< 0.1%
144000	16	< 0.1%
156000	38	< 0.1%
168000	39	< 0.1%
180000	58	< 0.1%
192000	52	< 0.1%

Value	Count	Frequency (%)
12768000	7	< 0.1%
12024000	2	< 0.1%
11496000	3	< 0.1%
11448000	2	< 0.1%
11316000	2	< 0.1%
11124000	7	< 0.1%
10824000	10	< 0.1%
10752000	1	< 0.1%
10728000	1	< 0.1%
10452000	10	< 0.1%

AbsoluteTopImpressionPercentage
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	101
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.30132991

Minimum	0
Maximum	1.2
Zeros	314320
Zeros (%)	53.5%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.60000002
95-th percentile	1.2
Maximum	1.2
Range	1.2
Interquartile range (IQR)	0.60000002

Descriptive statistics

Standard deviation	0.39921892
Coefficient of variation (CV)	1.3248566
Kurtosis	-0.22582053
Mean	0.30132991
Median Absolute Deviation (MAD)	0
Skewness	1.0528615
Sum	177047.59
Variance	0.15937574
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	314320	53.5%
1.200000048	46037	7.8%
0.6000000238	29220	5.0%
0.3959999979	16659	2.8%
0.80400002	12684	2.2%
0.3000000119	9912	1.7%
0.2399999946	6572	1.1%
0.4799999893	6558	1.1%
0.8999999762	6408	1.1%
0.7200000286	5518	0.9%
Other values (91)	133666	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	314320	53.5%
0.0120000001	60	< 0.1%
0.02400000021	260	< 0.1%
0.03599999845	478	0.1%
0.04800000042	657	0.1%
0.05999999866	839	0.1%
0.0719999969	1136	0.2%
0.08399999887	1229	0.2%
0.09600000083	1741	0.3%
0.1080000028	1461	0.2%

Value	Count	Frequency (%)
1.200000048	46037	7.8%
1.187999964	18	< 0.1%
1.175999999	69	< 0.1%
1.164000034	137	< 0.1%
1.15199995	201	< 0.1%
1.139999986	231	< 0.1%
1.128000021	317	0.1%
1.116000056	428	0.1%
1.103999972	595	0.1%
1.092000008	537	0.1%

TopImpressionPercentage
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	95
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.66347919

Minimum	0
Maximum	1.2
Zeros	236197
Zeros (%)	40.2%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.99599999
Q3	1.2
95-th percentile	1.2
Maximum	1.2
Range	1.2
Interquartile range (IQR)	1.2

Descriptive statistics

Standard deviation	0.55828428
Coefficient of variation (CV)	0.84144958
Kurtosis	-1.8322337
Mean	0.66347919
Median Absolute Deviation (MAD)	0.20400006
Skewness	-0.28218454
Sum	389829.85
Variance	0.31168133
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	236197	40.2%
1.200000048	212350	36.1%
0.6000000238	8822	1.5%
0.80400002	8290	1.4%
0.8999999762	7446	1.3%
0.9599999785	6682	1.1%
0.9959999919	6479	1.1%
1.055999994	6428	1.1%
1.103999972	6128	1.0%
1.128000021	6106	1.0%
Other values (85)	82626	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	236197	40.2%
0.0719999969	1	< 0.1%
0.09600000083	2	< 0.1%
0.1080000028	4	< 0.1%
0.1199999973	3	< 0.1%
0.1319999993	15	< 0.1%
0.1439999938	6	< 0.1%
0.1560000032	18	< 0.1%
0.1679999977	33	< 0.1%
0.1800000072	3	< 0.1%

Value	Count	Frequency (%)
1.200000048	212350	36.1%
1.187999964	2525	0.4%
1.175999999	4128	0.7%
1.164000034	5064	0.9%
1.15199995	5530	0.9%
1.139999986	5894	1.0%
1.128000021	6106	1.0%
1.116000056	5867	1.0%
1.103999972	6128	1.0%
1.092000008	4863	0.8%

SearchImpressionShare
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7826
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.068268

Minimum	0
Maximum	100
Zeros	193541
Zeros (%)	32.9%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	42.110001
Q3	85.709999
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	85.709999

Descriptive statistics

Standard deviation	40.331276
Coefficient of variation (CV)	0.91519994
Kurtosis	-1.6263129
Mean	44.068268
Median Absolute Deviation (MAD)	42.110001
Skewness	0.17690049
Sum	25892487
Variance	1626.6117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	193541	32.9%
100	107201	18.2%
10	44317	7.5%
50	23337	4.0%
66.66999817	15420	2.6%
75	10692	1.8%
33.33000183	9093	1.5%
80	7590	1.3%
60	5705	1.0%
83.33000183	5534	0.9%
Other values (7816)	165124	28.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	193541	32.9%
10	44317	7.5%
10.02000046	2	< 0.1%
10.02999973	1	< 0.1%
10.03999996	2	< 0.1%
10.05000019	3	< 0.1%
10.06000042	3	< 0.1%
10.06999969	1	< 0.1%
10.07999992	6	< 0.1%
10.09000015	6	< 0.1%

Value	Count	Frequency (%)
100	107201	18.2%
99.69999695	1	< 0.1%
99.68000031	1	< 0.1%
99.62000275	1	< 0.1%
99.58000183	1	< 0.1%
99.55000305	1	< 0.1%
99.48999786	1	< 0.1%
99.48000336	1	< 0.1%
99.47000122	1	< 0.1%
99.44000244	1	< 0.1%

SearchTopImpressionShare
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	92
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.48930752

Minimum	0
Maximum	1.2
Zeros	193576
Zeros (%)	32.9%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.396
Q3	0.93599999
95-th percentile	1.2
Maximum	1.2
Range	1.2
Interquartile range (IQR)	0.93599999

Descriptive statistics

Standard deviation	0.4670651
Coefficient of variation (CV)	0.95454306
Kurtosis	-1.5037576
Mean	0.48930752
Median Absolute Deviation (MAD)	0.396
Skewness	0.31756485
Sum	287494.59
Variance	0.21814981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	193576	32.9%
1.200000048	89221	15.2%
0.1199999973	55158	9.4%
0.6000000238	26025	4.4%
0.80400002	16415	2.8%
0.8999999762	11092	1.9%
0.3959999979	11019	1.9%
0.9599999785	7971	1.4%
0.7200000286	6639	1.1%
0.9959999919	6304	1.1%
Other values (82)	164134	27.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	193576	32.9%
0.1199999973	55158	9.4%
0.1319999993	1579	0.3%
0.1439999938	985	0.2%
0.1560000032	1905	0.3%
0.1679999977	2159	0.4%
0.1800000072	1220	0.2%
0.1920000017	932	0.2%
0.2039999962	2637	0.4%
0.2160000056	1334	0.2%

Value	Count	Frequency (%)
1.200000048	89221	15.2%
1.187999964	71	< 0.1%
1.175999999	440	0.1%
1.164000034	831	0.1%
1.15199995	1291	0.2%
1.139999986	1644	0.3%
1.128000021	2118	0.4%
1.116000056	2298	0.4%
1.103999972	2865	0.5%
1.092000008	2545	0.4%

SearchRankLostTopImpressionShare
Real number (ℝ)

Distinct	91
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3155065

Minimum	0
Maximum	1.08
Zeros	282797
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.096000001
Q3	0.60000002
95-th percentile	1.08
Maximum	1.08
Range	1.08
Interquartile range (IQR)	0.60000002

Descriptive statistics

Standard deviation	0.38655034
Coefficient of variation (CV)	1.2251739
Kurtosis	-0.73706323
Mean	0.3155065
Median Absolute Deviation (MAD)	0.096000001
Skewness	0.86091286
Sum	185377.11
Variance	0.14942117
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	282797	48.1%
1.080000043	55156	9.4%
0.6000000238	26026	4.4%
0.3959999979	16472	2.8%
0.3000000119	11092	1.9%
0.80400002	10983	1.9%
0.2399999946	7972	1.4%
0.4799999893	6639	1.1%
0.2039999962	6254	1.1%
0.8999999762	5891	1.0%
Other values (81)	158272	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	282797	48.1%
0.0120000001	71	< 0.1%
0.02400000021	401	0.1%
0.03599999845	871	0.1%
0.04800000042	1291	0.2%
0.05999999866	1647	0.3%
0.0719999969	2119	0.4%
0.08399999887	2263	0.4%
0.09600000083	2900	0.5%
0.1080000028	2542	0.4%

Value	Count	Frequency (%)
1.080000043	55156	9.4%
1.067999959	1578	0.3%
1.055999994	1932	0.3%
1.04400003	959	0.2%
1.031999946	2155	0.4%
1.019999981	1223	0.2%
1.008000016	935	0.2%
0.9959999919	2659	0.5%
0.9840000272	1312	0.2%
0.9720000029	1156	0.2%

Impressions
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1989
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.378937

Minimum	0
Maximum	12901
Zeros	228327
Zeros (%)	38.9%
Negative	0
Negative (%)	0.0%
Memory size	5.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	14
95-th percentile	87
Maximum	12901
Range	12901
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	136.80074
Coefficient of variation (CV)	5.6114317
Kurtosis	1559.9833
Mean	24.378937
Median Absolute Deviation (MAD)	3
Skewness	29.862713
Sum	14323942
Variance	18714.442
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	228327	38.9%
2	29574	5.0%
1	28488	4.8%
3	27978	4.8%
4	20605	3.5%
5	17198	2.9%
6	15819	2.7%
7	13322	2.3%
8	11573	2.0%
9	10565	1.8%
Other values (1979)	184105	31.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	228327	38.9%
1	28488	4.8%
2	29574	5.0%
3	27978	4.8%
4	20605	3.5%
5	17198	2.9%
6	15819	2.7%
7	13322	2.3%
8	11573	2.0%
9	10565	1.8%

Value	Count	Frequency (%)
12901	1	< 0.1%
12194	1	< 0.1%
12025	1	< 0.1%
11903	1	< 0.1%
11467	1	< 0.1%
11115	1	< 0.1%
11034	1	< 0.1%
10137	1	< 0.1%
10054	1	< 0.1%
9668	1	< 0.1%

Clicks
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	469
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.589458

Minimum	0
Maximum	1322.4
Zeros	370319
Zeros (%)	63.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.2
95-th percentile	9.6000004
Maximum	1322.4
Range	1322.4
Interquartile range (IQR)	1.2

Descriptive statistics

Standard deviation	16.07102
Coefficient of variation (CV)	6.2063259
Kurtosis	1485.7898
Mean	2.589458
Median Absolute Deviation (MAD)	0
Skewness	31.818684
Sum	1521446.4
Variance	258.27771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	370319	63.0%
1.200000048	79574	13.5%
2.400000095	40640	6.9%
3.599999905	23907	4.1%
4.800000191	15653	2.7%
6	10722	1.8%
7.199999809	7971	1.4%
8.399999619	6072	1.0%
9.600000381	4619	0.8%
10.80000019	3668	0.6%
Other values (459)	24409	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	370319	63.0%
1.200000048	79574	13.5%
2.400000095	40640	6.9%
3.599999905	23907	4.1%
4.800000191	15653	2.7%
6	10722	1.8%
7.199999809	7971	1.4%
8.399999619	6072	1.0%
9.600000381	4619	0.8%
10.80000019	3668	0.6%

Value	Count	Frequency (%)
1322.400024	1	< 0.1%
1274.400024	1	< 0.1%
1246.800049	1	< 0.1%
1231.199951	1	< 0.1%
1203.599976	1	< 0.1%
1150.800049	1	< 0.1%
1141.199951	1	< 0.1%
1074	1	< 0.1%
1063.199951	1	< 0.1%
1024.800049	1	< 0.1%

Cost
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6883
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2624619.4

Minimum	0
Maximum	1.754172 × 10⁹
Zeros	370319
Zeros (%)	63.0%
Negative	0
Negative (%)	0.0%
Memory size	9.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1500000
95-th percentile	9648000
Maximum	1.754172 × 10⁹
Range	1.754172 × 10⁹
Interquartile range (IQR)	1500000

Descriptive statistics

Standard deviation	18296424
Coefficient of variation (CV)	6.9710771
Kurtosis	1766.9798
Mean	2624619.4
Median Absolute Deviation (MAD)	0
Skewness	34.589184
Sum	1.5421056 × 10¹²
Variance	3.3475913 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	370319	63.0%
792000	849	0.1%
744000	849	0.1%
960000	847	0.1%
816000	838	0.1%
828000	808	0.1%
888000	807	0.1%
696000	805	0.1%
936000	799	0.1%
720000	797	0.1%
Other values (6873)	209836	35.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	370319	63.0%
12000	22	< 0.1%
24000	5	< 0.1%
36000	3	< 0.1%
60000	22	< 0.1%
72000	3	< 0.1%
84000	6	< 0.1%
96000	9	< 0.1%
108000	24	< 0.1%
120000	27	< 0.1%

Value	Count	Frequency (%)
1754172000	1	< 0.1%
1490676000	1	< 0.1%
1472844000	1	< 0.1%
1414968000	1	< 0.1%
1396680000	1	< 0.1%
1393980000	1	< 0.1%
1388676000	1	< 0.1%
1365960000	1	< 0.1%
1341528000	1	< 0.1%
1316916000	1	< 0.1%

Sessions
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	470
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5893171

Minimum	0
Maximum	1322.4
Zeros	370324
Zeros (%)	63.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.2
95-th percentile	9.6000004
Maximum	1322.4
Range	1322.4
Interquartile range (IQR)	1.2

Descriptive statistics

Standard deviation	16.07053
Coefficient of variation (CV)	6.2064743
Kurtosis	1485.8749
Mean	2.5893171
Median Absolute Deviation (MAD)	0
Skewness	31.819334
Sum	1521363.6
Variance	258.2619
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	370324	63.0%
1.200000048	79571	13.5%
2.400000095	40643	6.9%
3.599999905	23909	4.1%
4.800000191	15648	2.7%
6	10725	1.8%
7.199999809	7966	1.4%
8.399999619	6074	1.0%
9.600000381	4620	0.8%
10.80000019	3666	0.6%
Other values (460)	24408	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	370324	63.0%
1.200000048	79571	13.5%
2.400000095	40643	6.9%
3.599999905	23909	4.1%
4.800000191	15648	2.7%
6	10725	1.8%
7.199999809	7966	1.4%
8.399999619	6074	1.0%
9.600000381	4620	0.8%
10.80000019	3666	0.6%

Value	Count	Frequency (%)
1322.400024	1	< 0.1%
1274.400024	1	< 0.1%
1246.800049	1	< 0.1%
1231.199951	1	< 0.1%
1203.599976	1	< 0.1%
1150.800049	1	< 0.1%
1141.199951	1	< 0.1%
1074	1	< 0.1%
1063.199951	1	< 0.1%
1024.800049	1	< 0.1%

Cost_gbp
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	6880
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6769503

Minimum	0
Maximum	1789.2555
Zeros	370324
Zeros (%)	63.0%
Negative	0
Negative (%)	0.0%
Memory size	6.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1.53
95-th percentile	9.8409595
Maximum	1789.2555
Range	1789.2555
Interquartile range (IQR)	1.53

Descriptive statistics

Standard deviation	18.661524
Coefficient of variation (CV)	6.971188
Kurtosis	1767.1128
Mean	2.6769503
Median Absolute Deviation (MAD)	0
Skewness	34.589706
Sum	1572852.9
Variance	348.25247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	370324	63.0%
0.7588800192	849	0.1%
0.8078399897	849	0.1%
0.9792000055	847	0.1%
0.8323199749	838	0.1%
0.9057599902	807	0.1%
0.8445600271	807	0.1%
0.7099199891	804	0.1%
0.9547200203	799	0.1%
0.7343999743	797	0.1%
Other values (6870)	209833	35.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	370324	63.0%
0.01224000007	22	< 0.1%
0.02448000014	5	< 0.1%
0.03672000021	3	< 0.1%
0.06120000035	22	< 0.1%
0.07344000041	3	< 0.1%
0.08568000048	6	< 0.1%
0.09792000055	9	< 0.1%
0.1101600006	24	< 0.1%
0.1224000007	27	< 0.1%

Value	Count	Frequency (%)
1789.255493	1	< 0.1%
1520.489502	1	< 0.1%
1502.300903	1	< 0.1%
1443.267334	1	< 0.1%
1424.613647	1	< 0.1%
1421.859619	1	< 0.1%
1416.449463	1	< 0.1%
1393.279175	1	< 0.1%
1368.358521	1	< 0.1%
1343.254272	1	< 0.1%

Margin
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	18624
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9361715

Minimum	-122.14581
Maximum	2349.5994
Zeros	568930
Zeros (%)	96.8%
Negative	21
Negative (%)	< 0.1%
Memory size	6.7 MiB

Quantile statistics

Minimum	-122.14581
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2349.5994
Range	2471.7452
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	24.626743
Coefficient of variation (CV)	12.719299
Kurtosis	1638.5544
Mean	1.9361715
Median Absolute Deviation (MAD)	0
Skewness	32.5578
Sum	1137605.3
Variance	606.47644
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	568930	96.8%
5.330278873	2	< 0.1%
67.53459167	1	< 0.1%
20.54398155	1	< 0.1%
74.61479187	1	< 0.1%
41.43907928	1	< 0.1%
12.29122353	1	< 0.1%
71.10586548	1	< 0.1%
32.89949036	1	< 0.1%
4.488942146	1	< 0.1%
Other values (18614)	18614	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.1458054	1	< 0.1%
-83.62361908	1	< 0.1%
-83.52625275	1	< 0.1%
-83.43190765	1	< 0.1%
-32.88007736	1	< 0.1%
-29.41637802	1	< 0.1%
-19.80197906	1	< 0.1%
-16.08289146	1	< 0.1%
-9.859479904	1	< 0.1%
-6.271931171	1	< 0.1%

Value	Count	Frequency (%)
2349.599365	1	< 0.1%
2171.451904	1	< 0.1%
2006.36377	1	< 0.1%
1935.915283	1	< 0.1%
1902.381958	1	< 0.1%
1896.382446	1	< 0.1%
1850.828247	1	< 0.1%
1797.886108	1	< 0.1%
1783.546875	1	< 0.1%
1771.375366	1	< 0.1%

ROI_gbp
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	15964
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.35440124

Minimum	-57.280102
Maximum	1582.5066
Zeros	571589
Zeros (%)	97.3%
Negative	21
Negative (%)	< 0.1%
Memory size	6.7 MiB

Quantile statistics

Minimum	-57.280102
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1582.5066
Range	1639.7867
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.0511198
Coefficient of variation (CV)	19.895867
Kurtosis	8380.4639
Mean	0.35440124
Median Absolute Deviation (MAD)	0
Skewness	68.26133
Sum	208229.86
Variance	49.718292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	571589	97.3%
4.954443455	2	< 0.1%
1.238139987	2	< 0.1%
1.482692361	1	< 0.1%
0.3272510767	1	< 0.1%
6.681012154	1	< 0.1%
0.4683260024	1	< 0.1%
62.15295792	1	< 0.1%
0.4003099203	1	< 0.1%
1.247957706	1	< 0.1%
Other values (15954)	15954	2.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-57.28010178	1	< 0.1%
-37.49472809	1	< 0.1%
-28.348526	1	< 0.1%
-20.98656845	1	< 0.1%
-5.641546726	1	< 0.1%
-4.656144619	1	< 0.1%
-4.570081234	1	< 0.1%
-1.459805846	1	< 0.1%
-1.203261614	1	< 0.1%
-1.094004273	1	< 0.1%

Value	Count	Frequency (%)
1582.506592	1	< 0.1%
1121.160278	1	< 0.1%
799.2728271	1	< 0.1%
795.7611084	1	< 0.1%
756.4002075	1	< 0.1%
728.3591309	1	< 0.1%
696.4936523	1	< 0.1%
696.1707153	1	< 0.1%
633.7678833	1	< 0.1%
587.43573	1	< 0.1%

Auto

Heatmap
Table

	AdGroupId	CampaignId	CriterionId	CpcBid	AbsoluteTopImpressionPercentage	TopImpressionPercentage	SearchImpressionShare	SearchTopImpressionShare	SearchRankLostTopImpressionShare	Impressions	Clicks	Cost	Sessions	Cost_gbp	Margin	ROI_gbp	CampaignName
AdGroupId	1.000	-0.695	-0.111	0.038	0.077	0.061	0.019	0.029	0.118	0.111	0.068	0.060	0.068	0.060	0.017	0.019	0.818
CampaignId	-0.695	1.000	0.015	-0.113	-0.020	-0.036	-0.009	-0.014	-0.107	-0.083	-0.033	-0.034	-0.033	-0.034	-0.025	-0.024	1.000
CriterionId	-0.111	0.015	1.000	0.012	-0.159	-0.175	-0.146	-0.161	-0.209	-0.185	-0.146	-0.142	-0.146	-0.142	-0.048	-0.046	0.222
CpcBid	0.038	-0.113	0.012	1.000	0.096	0.043	0.038	0.051	-0.120	-0.039	-0.042	0.006	-0.042	0.006	-0.013	-0.015	0.059
AbsoluteTopImpressionPercentage	0.077	-0.020	-0.159	0.096	1.000	0.699	0.650	0.688	0.205	0.712	0.597	0.614	0.597	0.614	0.123	0.133	0.056
TopImpressionPercentage	0.061	-0.036	-0.175	0.043	0.699	1.000	0.811	0.874	0.213	0.674	0.471	0.482	0.471	0.482	0.086	0.086	0.050
SearchImpressionShare	0.019	-0.009	-0.146	0.038	0.650	0.811	1.000	0.977	0.180	0.713	0.513	0.525	0.513	0.525	0.112	0.115	0.058
SearchTopImpressionShare	0.029	-0.014	-0.161	0.051	0.688	0.874	0.977	1.000	0.149	0.712	0.533	0.547	0.533	0.547	0.117	0.121	0.055
SearchRankLostTopImpressionShare	0.118	-0.107	-0.209	-0.120	0.205	0.213	0.180	0.149	1.000	0.461	0.268	0.248	0.268	0.248	0.073	0.067	0.054
Impressions	0.111	-0.083	-0.185	-0.039	0.712	0.674	0.713	0.712	0.461	1.000	0.795	0.785	0.795	0.785	0.216	0.230	0.012
Clicks	0.068	-0.033	-0.146	-0.042	0.597	0.471	0.513	0.533	0.268	0.795	1.000	0.990	1.000	0.990	0.230	0.267	0.007
Cost	0.060	-0.034	-0.142	0.006	0.614	0.482	0.525	0.547	0.248	0.785	0.990	1.000	0.990	1.000	0.225	0.261	0.007
Sessions	0.068	-0.033	-0.146	-0.042	0.597	0.471	0.513	0.533	0.268	0.795	1.000	0.990	1.000	0.990	0.230	0.267	0.007
Cost_gbp	0.060	-0.034	-0.142	0.006	0.614	0.482	0.525	0.547	0.248	0.785	0.990	1.000	0.990	1.000	0.225	0.261	0.007
Margin	0.017	-0.025	-0.048	-0.013	0.123	0.086	0.112	0.117	0.073	0.216	0.230	0.225	0.230	0.225	1.000	0.925	0.005
ROI_gbp	0.019	-0.024	-0.046	-0.015	0.133	0.086	0.115	0.121	0.067	0.230	0.267	0.261	0.267	0.261	0.925	1.000	0.004
CampaignName	0.818	1.000	0.222	0.059	0.056	0.050	0.058	0.055	0.054	0.012	0.007	0.007	0.007	0.007	0.005	0.004	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	AdGroupId	CampaignId	CriterionId	Date	CampaignName	AdGroupName	Criteria	CpcBid	AbsoluteTopImpressionPercentage	TopImpressionPercentage	SearchImpressionShare	SearchTopImpressionShare	SearchRankLostTopImpressionShare	Impressions	Clicks	Cost	Sessions	Cost_gbp
0	146372240840	19026016545	1224358859735	2022-10-07	GEN_Date	GEN_2023_Easter_Exact	easter 2023 holidays	1824000.0	0.000	0.000	10.000000	0.120	1.080	0	0.0	0.0	0.0	0.00000
1	143665838613	19032609979	436468614376	2022-11-17	GEN_Type_Type	GEN_5 Star_Beach_BMM	+beach +holidays +5 +star	2160000.0	0.348	1.200	53.849998	0.648	0.552	9	0.0	0.0	0.0	0.00000
2	142284478245	19032615052	151556316	2022-09-21	GEN_Type_Date	GEN_Cheap_Christmas_Exact	cheap christmas vacations	708000.0	0.900	1.200	100.000000	1.200	0.000	9	1.2	1008000.0	1.2	1.02816
3	142284480445	19032615052	11690633763	2022-10-20	GEN_Type_Date	GEN_Deals_January_Exact	jan holiday deals	2544000.0	0.000	0.000	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
4	146372241280	19026016545	1416199961232	2022-11-17	GEN_Date	GEN_2023_August_BMM	+august +vacations +2023	1260000.0	0.000	0.000	100.000000	0.120	1.080	3	0.0	0.0	0.0	0.00000
5	143665828533	19032609979	16736349532	2022-11-16	GEN_Type_Type	GEN_Cheap_Low Deposit_Exact	cheap holiday deposits	2100000.0	0.000	0.600	50.000000	0.300	0.900	4	0.0	0.0	0.0	0.00000
6	142284482085	19032615052	347498971094	2022-10-04	GEN_Type_Date	GEN_Group_Summer_Exact	summer group holiday	1800000.0	0.000	0.000	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
7	146372240520	19026016545	1224358863975	2023-01-29	GEN_Date _Metis	GEN_2023_November_Exact	holidays in november 2023	936000.0	0.000	0.396	60.000000	0.240	0.960	7	0.0	0.0	0.0	0.00000
8	143665842653	19032609979	319550065624	2023-01-11	GEN_Type_Type _Metis	GEN_Resorts_Spa_Exact	spa resort holidays	756000.0	0.228	1.032	37.169998	0.384	0.816	68	2.4	1920000.0	2.4	1.95840
9	146372237640	19026016545	1109001691320	2022-10-03	GEN_Date	GEN_2022_Easter_Exact	easter 2022 holidays	3624000.0	0.000	0.000	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000

	AdGroupId	CampaignId	CriterionId	Date	CampaignName	AdGroupName	Criteria	CpcBid	AbsoluteTopImpressionPercentage	TopImpressionPercentage	SearchImpressionShare	SearchTopImpressionShare	SearchRankLostTopImpressionShare	Impressions	Clicks	Cost	Sessions	Cost_gbp
587583	146372243200	19026016545	1222333096249	2022-11-17	GEN_Date	GEN_2023_May_Exact	may vacations 2023	1752000.0	0.00	0.0	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
587584	140745286301	19032615052	1221947359820	2022-10-16	GEN_Type_Date	GEN_Villa_2023_BMM	+holiday +villas +2023	1356000.0	0.00	0.0	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
587585	140745267781	19032615052	1224447894125	2022-10-15	GEN_Type_Date	GEN_Cheap_2023_February_Exact	cheap holidays feb 2023	2064000.0	0.00	1.2	100.000000	1.200	0.000	2	1.2	660000.0	1.2	0.67320
587586	142284510685	19032615052	342181387139	2022-12-01	GEN_Type_Date _Metis	GEN_Adult_Winter_BMM	+adult +only +winter +sun +holidays	1008000.0	1.20	1.2	100.000000	1.200	0.000	3	0.0	0.0	0.0	0.00000
587587	146372244440	19026016545	1743196680684	2022-11-04	GEN_Date	GEN_2024_December_Exact	holidays in december 2024	492000.0	0.00	0.0	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
587588	142284485205	19032615052	5401824870	2022-12-10	GEN_Type_Date _Metis	GEN_Singles_Christmas_Exact	xmas singles holidays	1356000.0	0.72	1.2	86.959999	1.044	0.156	33	8.4	7284000.0	8.4	7.42968
587589	143665832053	19032609979	11391029012	2023-01-01	GEN_Type_Type _Metis	GEN_Group_Luxury_Exact	luxury group holiday	2136000.0	0.00	0.0	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000
587590	146372227880	19026016545	2643843441	2022-10-29	GEN_Date	GEN_December_Exact	holiday december	912000.0	0.00	1.2	87.500000	1.056	0.156	10	1.2	672000.0	1.2	0.68544
587591	143869938237	19032615541	310253803378	2022-11-06	GEN_From	GEN_Bristol_BMM	+holidays +from +bristol	1392000.0	1.20	1.2	25.000000	0.300	0.900	2	1.2	2208000.0	1.2	2.25216
587592	142284477005	19032615052	42997665378	2022-12-28	GEN_Type_Date _Metis	GEN_Beach_Christmas_Exact	xmas beach holiday	1392000.0	0.00	0.0	0.000000	0.000	0.000	0	0.0	0.0	0.0	0.00000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Connector Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Connector Punctuation

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Math Symbol

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample